This is a voluntary project conducted for a catfish farm in Abuja. The objective of the project was:
1. To present the list of debtors and how much they owe the catfish farm.
2. To analyze the data from the farm for useful insights for growth.
The data used was the sales record of the fish farm in excel format. The workbook contained 56 sheets detailing sales from different days. Each sheet contained the names of the buyer, the different types of fishes sold by the farm, the weight of the fishes in grams, the amount per gram for each fish, the total quantity of fish purchased by each buyer, the amount paid by the buyer, the balance unpaid (if applicable), and the balance owed by the farm (if applicable).
Insight 1: Fish types labeled “s” and “ss” in the sales records had the most sales on the farm. Approximately 61 % of all fish sold throughout the year from the fish farm were “s” (30.3 %) and “ss” (30.2 %). Meanwhile, negligible quantities of PRE-BROOD and BROODSTOCK fish was sold all year.
Insight 2: It was discovered that Mondays were the best days for sales. 76 % of all sales were made on a Monday. No sale was done on Tuesdays and Wednesdays. It should be noted that the cause of this trend can not be explained from the data set made available for this project. Future projects might consider looking further into this trend.
Insight 3: It can not be concluded from the data that any of the nationwide holidays in Nigeria, had any impact on the sales of fish. Future projects can look into the effect of other factors
The following R libraries were used for this project:
1. tidyverse
2. readxl
3. dplyr
4. reshape2
5. ggplot2
6. shiny
7. plotly
8. scales
what fish sells the most and the least?
PLOT 1
what days of the week had the most fish sales?
Plot 2
what was the revenue generation across the year, and was it affected by yearly events?
Plot 3